package com.asset.dispoal.business.addressCode.domain.db.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@Mapper
public interface AddressCodeMapper {
    void updateState(@Param("assetInstBatchId") String requestKey, @Param("state") String number);

    void updateFaildStateByCaseId(@Param("caseId") String caseId);

    void updateAddress(
            @Param("state") String state,
            @Param("caseId") String caseId,
            @Param("province") String province,
            @Param("city") String city,
            @Param("county") String county,
            @Param("town") String town,
            @Param("village") String village,
            @Param("fullAddress") String fullAddress,
            @Param("areaCode") String areaCode);

    String getAdCodeByName(@Param("name") String name, @Param("adcode") String number);

    String getExtractAdCodeByName(@Param("city") String province, @Param("address") String fullAddress);

    String getAdCodeByLikeProvince(@Param("county") String county, @Param("proCode") String substring);

    List<String> findAdCodeByLikeProvince(@Param("county") String county, @Param("proCode") String substring);
}
